// Decompiled by GOOSIN CO,LTD Copyright 2010 Pavel Kouznetsov.
// home page: http://www.Goosin.net
// Decompiler options: packimports(3) fieldsfirst ansi space 
// Source File Name:   getListPrice.java

package stock;

import include.nseer_db.nseer_db;
import java.sql.ResultSet;

public class getListPrice
{

	public getListPrice()
	{
	}

	public double getListPrice(String unit_db_name, String product_ID)
	{
		nseer_db dba = new nseer_db(unit_db_name);
		double list_price = 0.0D;
		try
		{
			String sql1 = (new StringBuilder("select list_price from design_file where product_ID='")).append(product_ID).append("'").toString();
			ResultSet rs1 = dba.executeQuery(sql1);
			if (rs1.next())
				list_price = rs1.getDouble("list_price");
			dba.close();
		}
		catch (Exception ex)
		{
			ex.printStackTrace();
		}
		return list_price;
	}
}
